package com.ilink.groundservice.mapper.model;

import com.ilink.groundservice.entity.PO.model.ModelTags;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author LENOVO
* @description 针对表【model_tags】的数据库操作Mapper
* @createDate 2024-09-16 19:04:48
* @Entity generator.domain.ModelTags
*/
@Mapper
public interface ModelTagsMapper extends BaseMapper<ModelTags> {
    @Select("SELECT tag FROM model_tags " +
        "WHERE tag IS NOT NULL AND tag <> '' " +
        "GROUP BY tag " +
        "ORDER BY COUNT(*) DESC " +
        "LIMIT 8")
    List<String> selectCommonTags();
}




